package com.example.demo.Mappers;

import com.example.demo.beans.DepartInfoBean;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;

import java.util.List;

/**
 * Created by Administrator on 2018/4/12.
 */
@Mapper
public interface GetRegDeptListMapper {
    @Select("select Rtrim(ksbm)DeptID, '0'ParDepId, Rtrim(ksms)DeptName from gyb_ks nolock where tybz='0' and sfghks='1'and (ksbm!='0001') and (ksbm!='0012') ")
    List<DepartInfoBean> GetDepart();
}
